会计科目
概述
科目
缺省科目
/* C_AcctSchema_Default 和 C_AcctSchema_GL 的53个默认字段 */
select b.tablename, a.columnname ,a.ismandatory,a.isactive, a.ad_reference_id from ad_column a
join ad_table b on a.ad_table_id=b.ad_table_id
where A.AD_Reference_ID =25
and upper(B.tablename) ~'_GL$|DEFAULT$'
and a.isactive='Y'
order by 1,2
参考:Msetup.createAccountingRecord 以及437行的引用
// Create Defaults Accounts
try {
createAccountingRecord(X_C_AcctSchema_GL.Table_Name);
createAccountingRecord(X_C_AcctSchema_Default.Table_Name);
}
catch (Exception e) {
String err = e.getLocalizedMessage();
log.log(Level.SEVERE, err);
m_info.append(err);
m_trx.rollback();
m_trx.close();
return false;
}
/* v4.1,67个默认科目,去掉22个固定资产科目,还剩45个 */
select distinct(d.columnname), d.ismandatory as columnismandatory , a.ismandatory as fieldismandatory, a.displaylogic from ad_field a
join ad_tab b on a.ad_tab_id=b.ad_tab_id
join ad_window c on b.ad_window_id=c.ad_window_id
join ad_column d on a.ad_column_id=d.ad_column_id
where d.AD_Reference_ID=25 /* 列为account类型 */
and c.isactive='Y' AND b.isactive='Y' AND d.isactive='Y' and a.isactive='Y' and a.isdisplayed='Y'
and b.name !~'Records|Test|Expense|History|Line' /* 去掉非账户设置页签 */
and d.columnname !~'^A_' /* 去掉固定资产科目 */
order by 2
/* 界面45个科目有4个科目比较特殊 */
CurrencyBalancing_Acct field显示逻辑输入
SuspenseBalancing_Acct field显示逻辑输入
P_AverageCostVariance_Acct field必填,column不必填 (通常field=null,column=Y)
P_LandedCostClearing_Acct field不必填,column不必填(通常field=null,column=Y)
/* 界面45个科目与账套53个科目差异的8个科目为废弃科目 */
CB_Asset_Acct field.isdisplayed='N'
CB_CashTransfer_Acct field.isdisplayed='N'
CB_Differences_Acct field.isdisplayed='N'
CB_Expense_Acct field.isdisplayed='N'
CB_Receipt_Acct field.isdisplayed='N'
C_Receivable_Services_Acct field.isdisplayed='N'
V_Liability_Services_Acct field.isdisplayed='N'
UnEarnedRevenue_Acct field.isacitve=N (取消都不一样)
/* 设置废弃科目为无效,请注意版本 */
update ad_column set isactive='N'
WHERE ad_column_id in (6493,5209,5208,5207,3455,5206,14430,4872)
默认科目(54个)
固定资产科目
常见报错